import os
from openpyxl import load_workbook

def get_sheet_names():  
  wb = load_workbook("数据持久化\\疫苗数据.xlsx")
  sheet_name_list = wb.sheetnames
  return sheet_name_list


lst = get_sheet_names()
for name in lst:
  os.system('copy 数据持久化\\疫苗数据.xlsx 数据持久化\\xlsx\\{}.xlsx'.format(name))
 
  wb = load_workbook("数据持久化\\xlsx\\{}.xlsx".format(name))
  sheet_name_list = wb.sheetnames
  for s in sheet_name_list:
    if s != name:
      wb.remove_sheet(wb.get_sheet_by_name(s))
  wb.save("数据持久化\\xlsx\\{}.xlsx".format(name))